drop database note;
create database note;
use note;

CREATE TABLE admin (adminName char(20) NOT NULL,
                      adminPasswd char(80) NOT NULL,
                      );

create table guest(noteId int NOT NULL auto_increment,
			userName char(20) NOT NULL,
			sex int NOT NUll,
			email char(50),
			qq char(9),
			url char(50),
			headTitle varchar(60) NOT NULL,
			content text NOT NULL,
			image varchar(20),
                        noteTime varchar(20),
			primary key(noteId)
			);

CREATE TABLE reply (replyId int not null auto_increment,
                        noteId int(11) NOT NULL,
                        content text,
                        replyTime varchar(20),
                        primary key(replyId)
                        );
